package com.cz.mydao.constant;

/**
 * @descriptions: 数据库关键词及符号常量类
 * @author: Joker.
 * @date: 2024/12/25 17:32
 * @version: 1.0
 */

public class SqlKey {
    public static final String CREATE_TABLE = "create table  ";
    public static final String CREATE_VIEW = "create view ";
    public static final String SELECT_ASTERISK_FROM = "select * from ";
    public static final String SELECT = "select ";
    public static final String DELETE = " delete ";
    public static final String UPDATE = " update ";
    public static final String INSERT_INTO = " insert into ";
    public static final String VALUES = " values ";
    public static final String AS = " as ";
    public static final String FROM = " from ";
    public static final String SPACE = " ";
    public static final String WHERE = " where ";
    public static final String EQUALS = " = ";
    public static final String IN = " in ";
    public static final String SET = " set ";
    public static final String OFFSET = " offset ";
    public static final String ROWS_FETCH_NEXT = " rows fetch next ";
    public static final String ROWS_ONLY = " rows only ";
    public static final String ORDER_BY = " order by ";
    public static final String LIMIT = " limit ";
    public static final String DISTINCT = " distinct ";
    public static final String LEFT_BRACKET = " ( ";
    public static final String RIGHT_BRACKET = " ) ";
    public static final String AND = " and ";
    public static final String BETWEEN = " between ";
    public static final String ASC = " asc ";
    public static final String DESC = " desc ";
    public static final String QUESTION_MARK = "?";
    public static final String ID = " id ";
    public static final String COMMA = ",";
    public static final String IS_DELETE = "is_delete";
    public static final String ZERO = " 0 ";
    public static final String MINUS_ONE = " -1 ";
    public static final String NOT_NULL = " not null ";
    public static final String NULL = " null ";
    public static final String PRIMARY_KEY = " primary key ";
    public static final String COMMENT = " comment ";
    public static final String SINGLE_QUOTATION_MARK = " ' ";
    public static final String VARCHAR_255 = "varchar(255)";
    public static final String VARCHAR_20 = "varchar(20)";
    public static final String VARCHAR_50 = "varchar(50)";
    public static final String VARCHAR_100 = "varchar(100)";
    public static final String BIGINT = "bigint";
    public static final String GENDER_ENUM = "ENUM('男', '女')";
    public static final String DATETIME = " datetime ";
    public static final String DOUBLE_10_2 = " double(10,2) ";

}



